/**
 * @author Cristian Ágreda. - cagredac@gmail.com
 * @company UDistrital.
 */
package co.edu.udistrital.conce.presentacion;

import co.edu.udistrital.negocio.excepcion.ConcesionarioExcepcion;
import co.edu.udistrital.negocio.excepcion.ExcepcionSistema;
import com.sun.rave.web.ui.appbase.AbstractPageBean;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.faces.FacesException;
import co.edu.udistrital.conce.presentacion.scope.ApplicationBean;
import co.edu.udistrital.conce.presentacion.scope.SessionBean;
import co.edu.udistrital.conce.presentacion.scope.RequestBean;
import co.edu.udistrital.conce.presentacion.util.DateUtil;
import co.edu.udistrital.negocio.modelo.ReporteCostosLineaTO;
import co.edu.udistrital.negocio.modelo.ReporteVehiculoTO;
import co.edu.udistrital.negocio.persistencia.ManejadorConexion;
import co.edu.udistrital.negocio.persistencia.ReporteCostosLineaView;
import co.edu.udistrital.negocio.persistencia.ReporteVehiculoView;
import java.sql.Connection;
import java.util.Calendar;
import java.util.Collection;
import java.util.Date;


/**
 * <p>Page bean that corresponds to a similarly named JSP page.  This
 * class contains component definitions (and initialization code) for
 * all components that you have defined on this page, as well as
 * lifecycle methods and event handlers where you may add behavior
 * to respond to incoming events.</p>
 */
public class ReporteCostoLinea extends AbstractPageBean {
    // <editor-fold defaultstate="collapsed" desc="Managed Component Definition">
    private int __placeholder;
    private int numRegistros;
    private Date fechaDesde;
    private Date fechaHasta;
    private boolean showReport = false;
    private Collection<ReporteCostosLineaTO> listaLineas;

    public int getNumRegistros() {
        return numRegistros;
    }

    public void setNumRegistros(int numRegistros) {
        this.numRegistros = numRegistros;
    }

    public boolean isShowReport() {
        return showReport;
    }

    public void setShowReport(boolean showReport) {
        this.showReport = showReport;
    }

    public Collection<ReporteCostosLineaTO> getListaLineas() {
        return listaLineas;
    }

    public void setListaLineas(Collection<ReporteCostosLineaTO> listaLineas) {
        this.listaLineas = listaLineas;
    }


    public Date getFechaDesde() {
        return fechaDesde;
    }

    public void setFechaDesde(Date fechaDesde) {
        this.fechaDesde = fechaDesde;
    }

    public Date getFechaHasta() {
        return fechaHasta;
    }

    public void setFechaHasta(Date fechaHasta) {
        this.fechaHasta = fechaHasta;
    }


    Connection  conexion = null;
    

    public Connection getConexion() {
        if(conexion==null){
            try {
                conexion = ManejadorConexion.obtenerConexion();
            } catch (ExcepcionSistema ex) {
                Logger.getLogger(IngresoAutoPage.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
        return conexion;
    }

  
    
    /**
     * <p>Automatically managed component initialization.  <strong>WARNING:</strong>
     * This method is automatically generated, so any user-specified code inserted
     * here is subject to being replaced.</p>
     */
    private void _init() throws Exception {
    }


    // </editor-fold>

    /**
     * <p>Construct a new Page bean instance.</p>
     */
    public ReporteCostoLinea() {
    }

    /**
     * <p>Callback method that is called whenever a page is navigated to,
     * either directly via a URL, or indirectly via page navigation.
     * Customize this method to acquire resources that will be needed
     * for event handlers and lifecycle methods, whether or not this
     * page is performing post back processing.</p>
     * 
     * <p>Note that, if the current request is a postback, the property
     * values of the components do <strong>not</strong> represent any
     * values submitted with this request.  Instead, they represent the
     * property values that were saved for this view when it was rendered.</p>
     */
    @Override
    public void init() {
        // Perform initializations inherited from our superclass
        super.init();
        // Perform application initialization that must complete
        // *before* managed components are initialized
        // TODO - add your own initialiation code here
            
        // <editor-fold defaultstate="collapsed" desc="Managed Component Initialization">
        // Initialize automatically managed components
        // *Note* - this logic should NOT be modified
        try {
            _init();
        } catch (Exception e) {
            log("WelcomePage Initialization Failure", e);
            throw e instanceof FacesException ? (FacesException) e: new FacesException(e);
        }
        
        // </editor-fold>
        // Perform application initialization that must complete
        // *after* managed components are initialized
        // TODO - add your own initialization code here
    }

    /**
     * <p>Callback method that is called after the component tree has been
     * restored, but before any event processing takes place.  This method
     * will <strong>only</strong> be called on a postback request that
     * is processing a form submit.  Customize this method to allocate
     * resources that will be required in your event handlers.</p>
     */
    @Override
    public void preprocess() {
    }

    /**
     * <p>Callback method that is called just before rendering takes place.
     * This method will <strong>only</strong> be called for the page that
     * will actually be rendered (and not, for example, on a page that
     * handled a postback and then navigated to a different page).  Customize
     * this method to allocate resources that will be required for rendering
     * this page.</p>
     */
    @Override
    public void prerender() {
         
        try {
        
         

        } catch (Exception ex) {
            Logger.getLogger(IngresoAutoPage.class.getName()).log(Level.SEVERE, null, ex);
        }

    }

    /**
     * <p>Callback method that is called after rendering is completed for
     * this request, if <code>init()</code> was called (regardless of whether
     * or not this was the page that was actually rendered).  Customize this
     * method to release resources acquired in the <code>init()</code>,
     * <code>preprocess()</code>, or <code>prerender()</code> methods (or
     * acquired during execution of an event handler).</p>
     */
    @Override
    public void destroy() {
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected ApplicationBean getscope$ApplicationBean() {
        return (ApplicationBean) getBean("scope$ApplicationBean");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected SessionBean getscope$SessionBean() {
        return (SessionBean) getBean("scope$SessionBean");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected RequestBean getscope$RequestBean() {
        return (RequestBean) getBean("scope$RequestBean");
    }

    public String consultar(){

        try {

            Calendar cal = Calendar.getInstance();
            Calendar cal2 = Calendar.getInstance();
            cal.setTime(fechaDesde);
            cal2.setTime(fechaHasta);


            if(cal.after(cal2)){
                 error("Fechas no coinciden");
                 return null;
            }

            this.showReport = true;
            ReporteCostosLineaView costoLineaView = new ReporteCostosLineaView(this.getConexion());
            this.listaLineas = costoLineaView.queryByWhere("fecha_entrada between '"+DateUtil.formatDate(fechaDesde, "yyyy-MM-dd") +"'and '"+DateUtil.formatDate(fechaHasta, "yyyy-MM-dd")+"'");
           
            if(this.listaLineas == null || this.listaLineas.isEmpty()){
                error("No existen registros en el periodo de tiempo");
                this.showReport = false;
            }



        } catch (ConcesionarioExcepcion ex) {
            Logger.getLogger(ReporteIngreoVehiculoPage.class.getName()).log(Level.SEVERE, null, ex);
        }

        return null;
    }
  

}

